--use rd4_dwcr
--go
--select top 100 * from JDEPOPurchaseOrderDetail
--where OrderNumber=854511

use MicroStrategy_Views
go
select top 100 ordernumber, OrderTypeCode, LineNumber, ItemNumber,
	ExtendedPrice, ExtendedCost , TransactionDateID, GLDateID, RequestedDateID,
	MatchRecordType
	,StatusCodeNext,
	TransactionTypeID
from 
	Purchase_Star_Facts
where
OrderNumber in ( 854511, 854530, 855057) 
--and TransactionType=1


